﻿CREATE TABLE [dbo].[SystemUser] (
    [SystemUserID]           UNIQUEIDENTIFIER NOT NULL,
    [CreatedDate]            DATETIME         NOT NULL,
    [CreatedBy]              UNIQUEIDENTIFIER NOT NULL,
    [ModifiedDate]           DATETIME         NOT NULL,
    [ModifiedBy]             UNIQUEIDENTIFIER NOT NULL,
    [Deleted]                BIT              NOT NULL,
    [EmployeeID]             UNIQUEIDENTIFIER NOT NULL,
    [UserName]               VARCHAR (24)     NOT NULL,
    [Salt]                   VARCHAR (5000)   NOT NULL,
    [Password]               VARCHAR (5000)   NOT NULL,
    [LastLoginDate]          DATETIME         NOT NULL,
    [LastPasswordChangeDate] DATETIME         NOT NULL,
    [NextPasswordChangeDate] DATETIME         NOT NULL,
    [ApprovedBy]             UNIQUEIDENTIFIER NULL,
    [ApprovedDate]           DATETIME         NOT NULL,
    [IsApproved]             BIT              NOT NULL,
    [IsLoggedOn]             BIT              NOT NULL,
    [IsLockedOut]            BIT              NOT NULL
);

